Google Ads Data Source

Please enter the following parameters to connect to a Google Ads data source:

• Alias: name of the data source to be used in CData Virtuality Server
• Authentication: Google Ads requires the following fields in order to proceed with the OAuth 2.0 authentication:
  • Client Id, Client secret: should be generated in the Google Developer's console
  • Authorization code or Refresh token: are required to proceed with the OAuth 2.0 authorization. The authorization code is an one-time code used to fetch a permanent refresh token. The Get code button opens the Google Authorization web form used to generate the one-time code. This code should be copied from the web form to the "Auth code" field of the wizard. CData Virtuality Studio will get a refresh token for you when testing the connection or adding the data source. Once the refresh token is fetched it never expires and can be used freely in the future.
  • Developer token: is provided by Google, once the Ads API is enabled for the account.
  Please refer to the Google Ads authentication guide for more information.
• User agent: A non-empty string by which Google Team can identify your API Request if any problem arises.
• Connection parameters: additional connection parameters.
• Data source parameters: additional connection parameters.
• Translator parameters: additional translator parameters.

Below are some examples of the most common data source parameters, see the reference manual for the full list:

• importer.useFullSchemaName=TRUE - schema names will be prefixed to table names to avoid duplicates
• importer.importProcedures=TRUE - stored procedures will be imported
• importer.useProcedureSpecificName=TRUE - when two stored procedures being imported have identical names, an index will be appended to their names in order to avoid conflicts

To fetch the Refresh token press the Fetch Refresh token button.